-- ----------------------------
-- 该脚本用于删除自动生成的用户权限管理数据。在搭建初始环境的时候，不要执行该脚本。
-- 再次重新生成项目的时候，如果您在生成器中新增了用户权限相关的数据，而之前已经搭建好的数据库中，也存在了
-- 您自己手动插入的权限数据时，可以通过执行该脚本，将现有数据库表中，生成器生成的权限数据删除，删除之后，可以再执行新生成的数据库脚本数据。
-- 请仅在下面的数据库链接中执行该脚本。
-- 主数据源 [192.168.8.10:5432/cmedu_local]
-- ----------------------------

-- ----------------------------
-- 全部菜单数据
-- ----------------------------
BEGIN;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119003095041;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483648;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378337;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378338;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378339;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378340;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378341;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483649;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378343;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378344;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378345;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378346;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378347;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378348;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483650;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378350;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378351;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378352;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378353;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378354;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378355;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378356;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378357;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378358;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483651;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378360;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378361;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378362;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378363;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378364;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378365;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378366;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378367;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378368;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483652;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378370;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378371;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378372;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378373;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378374;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483653;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378376;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378377;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378378;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378379;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483656;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378383;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378384;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378385;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378386;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378387;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483657;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378389;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483658;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378391;
DELETE FROM "sys_menu" WHERE menu_id = 1963551119011483659;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378393;
DELETE FROM "sys_menu" WHERE menu_id = 1963551741018378394;

-- ----------------------------
-- 以下记录用于移动端，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM "sys_menu" WHERE menu_id = 1687821642446671872;
DELETE FROM "sys_menu" WHERE menu_id = 1688105082400280576;
DELETE FROM "sys_menu" WHERE menu_id = 1687821728979357696;

-- ----------------------------
-- 以下记录用于在线表单，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM "sys_menu" WHERE menu_id = 1634009076981567488;
DELETE FROM "sys_menu" WHERE menu_id = 1392786549942259712;
DELETE FROM "sys_menu" WHERE menu_id = 1392786950682841088;
DELETE FROM "sys_menu" WHERE menu_id = 1392786950682841089;
DELETE FROM "sys_menu" WHERE menu_id = 1392786476428693504;

-- ----------------------------
-- 以下记录用于报表打印，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM "sys_menu" WHERE menu_id = 1534897180643430400;
DELETE FROM "sys_menu" WHERE menu_id = 1517063268609298432;
DELETE FROM "sys_menu" WHERE menu_id = 1516291375656603648;
DELETE FROM "sys_menu" WHERE menu_id = 1515858207237476352;
DELETE FROM "sys_menu" WHERE menu_id = 1515858116057501696;
DELETE FROM "sys_menu" WHERE menu_id = 1515857992501694464;

-- ----------------------------
-- 以下记录用于工作流，这里的注释，是为了便于老用户进行手动数据补偿。
-- ----------------------------
DELETE FROM "sys_menu" WHERE menu_id = 1418057714138877952;
DELETE FROM "sys_menu" WHERE menu_id = 1418059005175009280;
DELETE FROM "sys_menu" WHERE menu_id = 1418057835631087616;
DELETE FROM "sys_menu" WHERE menu_id = 1418057835631087617;
DELETE FROM "sys_menu" WHERE menu_id = 1418058289182150656;
DELETE FROM "sys_menu" WHERE menu_id = 1418058744037642240;
DELETE FROM "sys_menu" WHERE menu_id = 1418059167532322816;
DELETE FROM "sys_menu" WHERE menu_id = 1418059283920064512;
DELETE FROM "sys_menu" WHERE menu_id = 1423161217970606080;
DELETE FROM "sys_menu" WHERE menu_id = 1418059167532322810;
DELETE FROM "sys_menu" WHERE menu_id = 1418059167532322811;
DELETE FROM "sys_menu" WHERE menu_id = 1418059283920064515;
DELETE FROM "sys_menu" WHERE menu_id = 1418059283920064516;
COMMIT;
